MacWorld 1996 July

home *** CD-ROM | disk | FTP | other *** search

/ MacWorld 1996 July / Macworld (1996-07).dmg / System 7.5 Update 2.0 / FileMaker Pro 3.0 CD Extras / FileMaker Examples / Templates w⁄data / Business / Personnel Records (.txt) < prev next >

Wrap

FileMaker Pro Database | 1996-01-25 | 187KB | 944 lines

Xs^i~do= G8a Z pK^j HBAM2016AUG95 Pro 3.0 +b^"1 aAo%S TKj&i #"l6u 1Ya}M HBAM3016AUG95@ HP DeskJet 540 Printer Pro 2.0 - 2.1F! Pro 3.0 CREATED BY DATE CREATED DATE MODIFIED DATE OF BIRTH DATE OF HIRE DATE OF NEXT REVIEW DEPARTMENT EMERGENCY CONTACT EMERGENCY PHONE EMPLOYEE ID EMPLOYEE PICTURE EMPLOYEE TYPE FIRST NAME GENDER HOME CITY HOME PHONE HOME STATE HOME STREET HOME ZIP CODE LAST LAYOUT . LAST NAME MANAGER NOTES PAY GRADE PHONE\EXTENSION SALARY SOCIAL SECURITY NUMBER TITLE Employee IDB A Last NameB First NameB SalaryB DepartmentB ManagerB A Pay GradeB TitleB Home Street USENG.NDX Sunday Monday Tuesday Wednesday Thursday Friday Saturday January February March April August September October November December 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 11/20/95 Description You can use this database file to maintain employee data such as hire date, salary, manager, department, pay grade, and next review date. You can also include personal information. How to use this solution Use the phone dialing feature to quickly dial the employee's extension. In an emergency, you can click the telephone icon next to the emergency contact information to call the contact person. You can edit your phone dialing preferences in the Preferences dialog box. How to B customize this solution You can create a layout to print employee identification badges. You can also integrate this database with other databases, such as "Expense Reports" using lookups and relations. Form View - Job A List View Employee Phone List Information Report Menu A Home CityB Home StateB Home ZIP CodeB NotesB Phone\ExtensionB Date CreatedB Date ModifiedB Social Security NumberB X1Please enter a number in the form of 000-00-0000. ) = 11 ) GenderB Date of BirthB Date of HireB Date of Next ReviewB Home PhoneB Employee TypeB Employee PictureB Emergency ContactB Emergency PhoneB InfoB Created ByB Last LayoutB DavidsonD JulieE 125000G Human ResourcesK DirectorO 839 Eighth Ave.P Foster CityQ 94401U 7393Y 10/19/95_ 123-45-6789` Femalea 05/01/62e 5/2/95f 6/1/95g 415-555-0900h Full Timei Jack Davidsonk 408-555-2211 PamelaE 65000G Human ResourcesH Julie DavidsonK ManagerO 466 West Ave.P EckmanQ 24829U 7396Y 10/19/95_ 111-23-9845` Femalea 09/21/61e 5/18/93f 5/18/96g 712-555-5245h Full Timei Gj Peter Dayk 712-555-6357 LongD JackE 32000G MarketingH Dennis SmithK Marketing SpecialistO 88 Liberty St.P GrotonQ 01450U 3785Y 10/19/95_ 456-66-9877` Malea 3/15/65e 4/3/91f 4/3/96g 508-555-6899h Full Timei Gertrude Longk 608-555-6513 Form View - Personal Form View - JobB A List ViewB Your Own Buttons Your Own Buttont Recordu Delete Recordv Recordw Reportsx View As Listy View As Formz Close{ Info| Type} Social Security Number~ Date of Hire Next Review Salary A Pay Grade Manager Phone/Ext. Department Title Your Own Buttons Your Own Buttont Recordu Delete Recordv Recordw Reportsx View As Listy View As Formz Close{ Info| Type} Social Security Number~ Date of Hire Next Review Salary A Pay Grade Manager Phone/Ext. Department Title F Last Name First Name H ID Number Enter data for Employees Notes Personal Information Position Employee Employee Phone ListB Phone\Ext.P DepartmentQ TitleR Last NameS First NameT Your Own ButtonU Your Own ButtonV RecordW Delete RecordX RecordY ReportsZ View As List[ View As Form\ Close] Info^-Click to see more information for an Employee InformationB Your Own Buttonn Reportso View As Listp View As Formq Closer Infos Phonet Departmentu Titlev Last Namew Page ##y Employee Phone Listz First Name Report MenuB Your Own ButtonI ReportsJ View As ListK View As FormL CloseM InfoO0Information about the Personnel Records solutionP Info for this Solution ut the Personnel Records solutionP Info for this Solution Your Own ReportB Your Own ReportC Your Own ReportD Employee Phone ListE Your Own ButtonF ReportsG View As ListH View As FormI CloseJ InfoK>Click on any of these buttons to preview the respective reportL Select a report ButtonF ReportsG View As ListH View As FormI CloseJ InfoK>Click on any of these buttons to preview the respective reportL Select a report Form View - PersonalB Your Own ButtonB ReportsC View As ListD View As FormE CloseF Your Own Button{ Your Own Button| Record} Delete Record~ Record Reports View As View As Close Phone Emergency Contact Gender G Birthdate Phone ZIP Code Address Phone/Ext. Department Title P Last Name First Name R ID Number Personal Information Position Enter data for Employees Notes Employee Your Own ButtonB ReportsC View As ListD View As FormE CloseF Information List View Report Menu Sort by Department Sort by Last Name Employee Phone List Open Script Dial Extension Dial Home Phone Dial Emergency Phone Sort by Last Name Sort by Department Employee Phone List Open Script Dial Extension Dial Home Phone Dial Emergency Phone Information A List View Report Menu Helvetica Geneva Times Times New Roman Arial MS Sans Serif Cancel No records match this request.C) (LIST LISTA Female VDEFA( (LIST LISTA(Full Time Part Time Contractor Temporary VDEFA( Gender ListB Employee Type List wwwwww ffffff UUUUUU DDDDDD 3333B """""" #11#22122"3! "#""3"129 C3C3C34C4C3CC43C DDCD4DD4CDDC 4CDD4E4ET TEETEETUETUETUDUDEETUDTUE[ wwwwww ffffff UUUUUU DDDDDD 3333B """""" wwxwwxw ggvgvv gvwxgwghg vhgvvww fvfgfwffv eVefefe VvffVefVVefUe\ ffFdeefeefddfDeVdfEdfFdffk EUeFFEUFEUFFUeTeVFeUUdVEEk UTdUTeETeETeEUFTUTUFTUUTeK TEETEETUETUETUDUDEETUDTUE[ 4CDD4E4ET D4DD4CDDC C3C3C34C4C3CC43C "#""3"129 #11#22122"3! dUTeETeETeEUFTUTUFTUUTeK EUeFFEUFEUFFUeTeVFeUUdVEEk ffFdeefeefddfDeVdfEdfFdffk eVefefe VvffVefVVefUe\ fvfgfwffv ggvgvv gvwxgwghg vhgvvww Ejwwg wwxwwxw VPNRJ1J0F2J1VOZ RQRQ^ VqRORQRPI RQR1= J0Vs9 ZRVp1G R1RQA J1R0E N0N1E -RooX v0v0v v0zPvRvQz2v3z1z v1zRzszSzR~RzRz z2"~1v1r RSRSF RtNsA qJQ5j /N3w[ 3^-ZOj ^0frjOnsrrZ /J-sy JQNtNRJ0= JrF1= rVoN,R/NPVnf r1r1m J4JvN >3B3F3F4BS>2B B3F3B B3>2B3B4>4B3B4B >3>3B3 0Rsg8 JtF3B F4B4B3> B2F3B >4B3B1B0B #f/f.a F3B4B4> F3B3B3BSB4> B3F4B4B3B B3B2B >4>49 f/f/a B3B4F3B >4>4: B3B4B3B FT>35 f/f/j.f B3F4F4F3> >4>4F4B4>4: 3>3B3B4B3>2B3B4B4B f/f.f F4BUB 4B3>3BUB4B4> B4>4B3B4B >4>4B3F F4FTF4B3B B4>5>49 4>4>4B4B3>3> >3>3B2F3> F4JSBTB3B2B3>4: B4>4>4B4B4> >3B4> f/f0f/f B3FTFUB4B3B 4B4>4B4B4>4> B3B3> B3>3> B4BSB3B3B B4B4B3B4B4> B3BRB3B3FS9 F3B3B B4B4>4>4B >4BTB4B4>4B4>3>3B3BSB3>3> R/RQRrVpVpVsV VqVqZ VqJ.F R.ROVpVqVpZ N-R.VPZqb VPZpZ 0^RfTr n/vqnQj.a rrnRvqz ztrSj nQrrv vrvRrqvrrrb nPvQvsrrrQrrj0I /rQvrvqrPjP] /npnqnQjOf j/f.b b-^/^ /rPzqz nPf/] vqnOf PvqvrnN] /vqvrj/Y rQrRf0U b/f.a f1j0n j0r/rPrOn/j.j.jOj/b f/n/r0r0j n/n0rO rP+nPrOr/j/a n0r0r/j r/rPrQvQvPvQvQrOj/a r0j0j0n0r vR.zRvQrPn r0r0n0n r/v1zRzrzrzqvQn0e 0v1v1rQn0n v/vQzRzrz zrrQf/] r1vRv0q r1vRvRr1r0n r0r1vQzqzrvrjQf v1zSz /rRrRnQn1n n0r1vQzqzQnQf1fl /r0v0n1j1n n1r1vQvPv0n0j/j n1r0r/r/n0n.n j/n0n0n/n.j.j j.n.n.j j/j.f f/j0f/b f/j0f/b/Y j/j/f/a j/j/f f/n0j0j0j f.jPj/j j/j/j j1j1n1j0j/f j0jPnPr0n0j/n /j/j/j j.j0jPjPnOr0r0n1v0v/n f/j0n1r/r/n0r1r1r0n f0n1r0r 0r1rRrRv1r0j n1r1v2v2r1r0n j0f/b b0j0n0j0 f0j0f0f/] VSN2J2J2N1N2RSV b/j/n/jPjP j1j1j0b f/f/f VsRRRRNSR1R/R0RRVs^ b/f/r0nQjQf0f1f0f1jQj1fPj1f1f0f ZsVRR2N b0j1rQnRfRf1j1jQjR j1f0f 8&0F@EH Dd<D8 b0j0nQnSjsfQjPjQjQfRfSfRjQf0f <$8E8DDdH @c4F8$@ f/jQrsrsjS f1jRfQfPf 8#4%<dP wwwwww ffffff UUUUUU DDDDDD wwffeffg@ veUEDDCC vUTDD44 vUDDC32 #""# weUDD3 veTDC2233#3#2 wUDDC3##" +j,j+j*j f j+j+j*jKn+j *j+j+n*n+n,j*j*jKn*n j n*nLnLrLnLj+j*j*n*r n*j,n,r,P j+n+n n+n*j r,n,j+j r,n-j+j n+n,j j,j-j,n,n,n+n n,#n-n,n n,%r+r+n,n,n+j*j n-r-r-rMnL n,%n+r*n+n,r+n*n+j j.n.rNrMnM n+n,n-n,r+n-j j/n/nOnNnNj-j n,r-r-vMr.j j/nOnOn.j j-n.r/vOrOn0j/e f/rOrPnOj0j0n0nQj1f .rPrPj0f VLVoZ R+VMZm^ RMVmZ ?NNVoZnVmZ BVnZoZ NJ/N/N-F OJ/RORON.J-A .N/ZoVoVpVoRMJ NOZpVoV RNJ,I oVpRpVoZ RoRMR+J VpNpZ oRoROROVp^ VoVNVMVLN,I NOVqVP9f pRpVpNORn^ RoVoVnZmVLRMJ+A VoJ.RrVpA ZpRORMb wwwwww ffffff UUUUUU DDDDDD #4EWp "4EVx #3EVg "4DUg "#4DVg 24EVgy "34EVw ##4Efw ""3DUgw ""33DUfw ""34DVgx ""#34EVgx "#33DEfw " 234DUfw 2""2334DEVgx 3 4DEUfwx vUTD3#22 vUDDC fUD42233##3#"! vTDCC##" eUDC3223## fTD4C3##23#"" uTDC3323#2""! 22"2" ##2"! fTDD33#22"" vUDC32"2"" WUTC22 eTD3#"" GDC32"!! eD3#"! T32"" "%UR UD33D 3 DDUVgw D EUUfwx UDDEUUfgw U Vfgwx eUVfgww B"#B@ B"#B"$ 4"2$B"#B"#C 2$""#B"#C0 4"2#B"#C0 2$B"D0#C0 4""#C0 AD@D@ AD@D@ 44444 CCCCC 44444 CCCCC $42" @@BA@ bRBBP0 UUUUU JJJJ !BBBB "99BB #9999 $9911 %1111 &))))C '!!!! *00**- *00-00 00*0) 00*&0# ## !0*!%00+#!*0##-0'"0*#%00.! (*)(%,3& )%+@6) ",30,)% UUUUUU wwwwww #*>A6332+$"! 25,878 #&$690*" !)0,++)( "%/66435/'# +3;4*= !#,@9,)+,(""(-/,,*,1! !$&(265389,#!$$ '275? $*23/$ $),-..)'' !$&)(-5439@1!!&*-3/)!!%6B) )220(!$*.,,.' !$&*,*023:?B+*.,/3254.' "++,3/(.584.," !#&+/-./3:9@G@60/16883)! $++//'(9CD>4.$$ $%)*-//2693,.075-&)3792,$ ")-1347<>@G71(! **)&'*.0350+%(=A2'%)579<94( +/11! !%'),342)1?=0)" .1,$',-01)*).AG6-/048:<H /2583$%+66/% %)++*),+&%06,%$# !/40')-/31$$,@HFC<6887:==@B7%! 6A235,% +,/13.%#"(16+ !#$(04-$&+,+$ %2>D6,59:989889=0 ,.22<=33* .22671# !!&/42& *1$&+,/3779733, $$PQ /004B6* !$$ $))'/3) %&$&.7;4 )2$)*3-)466/%$ !),02+' %$5)%*+%$! (+'0:==4 $+,,1643"%)" !)/1)*+ +7=-%%&$! !3)3=. %&*/3113 !$$PQ ',4-%)/) ,6/%$$" +(!<- %),0354- .13-&,-* 14'$$! %))&%$! '3*$$" !&$%3 &%"%& 9836' )&#%%! $*)++" .-/:% !"&)()15, )" /.-+)!L //6B& #'*,.42$ $/,-*% IF1A1 "%.2/-*#! $/.,*($!#$"%PQ #57-*'$#"$&' ..//.-,)'(.212PQ ",,)&%'.;<6/+',,)%! '//,+//*)+.4:=>PQ $(&(),5?@:2/,,''*$ -!,,%.0%)./7 #43((+9CA=3+N &*)2!$96;;48@??PQ )/01%$ #3/').:@<3)$&)! /)4$%)8=A@?><@PQ !.0/.+//./1//* *.').3784/% ,,#%()25:<99=PQ %10//O 0 /+134,.25653." )++-! # %0,*,384'%PQ 42//11/&(/563135650( (./36$ !"23.,27- 6:=<)&931-13-!$.69433563+ ,/258 #$,96-37)$!P 38;?B>;63/.22.-068934673( ,638<6$ *),/6."')==138*$)PQ 35:=@B>953-/1.-368<:8995& %668:9( )$'*.:&$*==8/, -19=@CA>:83+2.,0157: !""/88$ !)*# 6/0% &' !$*38,.<;60" +07=@CD=6>@.*)&(*-03;@@<- 6.3/% #/23989=2,*% /039>B@ "9E7,)+/3667:?CE/!" $$%199207/ 9K8@) 3933" !0042381%$(.-)56PQ 556:=@@ 5C958=BGGA96;='"+- !!%.R 94.6BDCFM='(204967& //2346% $59232$PQ :9<@?@C% 6D;;CJLONG952 (9304=FCDDE>% $,585' !.//11'$/;81$ 9:CE><D3,5G@@HF>IF94) $#%+*159C=:>FG) *31*# $/51# 89C=.!:9=C<9AFGS CA7&( /%3%!'+5A<6=C>$ -672.3<<961.%! ,,%=<9/69/02. "773//33/,+) /1$'9<3)" 069850(*)'% %/+$ !&##34 %0<PQ %"$:C9.*$ !+6@PQ "$$6CD>>5 !##() ".;CPQ %'0>GFA:378+&&%$$,& ,:CPQ $(,0V 27CGG@6681//,)%$/ '7CPQ !%*/1,/44CC;6547@=2*!%.$ %;CPQ '$)=3 #%)*())3DLHB ?MB9/% ! "'6?6$ *;=PQ $%&,9D6 !$%#"&)-:FIJHFGFBN@91)%"#(,/./:/#$-46PQ !)/38;@( "$$!"+29?DGIJKMLEIC83)'&-7:73)%$!!,5:PQ +/0,$%&%%,26:5) "$%&(/7;<=BGIJIGMG=953'%(1<<63/! $*.8PQ 6=@?<3),3:8$ !&((),3=;::=EHIC:<F3)'""#&+/,', #&(0PQ FC8:CF@7/08<( "'()*,169?:6=C=2..3'" "%&)PQ HD99=A@9534/ !26(%5, ! !),''*-16<@=430/,+/)! ??979>@@:-! !$+%-*),/37<@:2/-*)+*" 4?=95;@@9& *#%.,/136884/,)'),,%)+(%$$ />C:13?@9)$ !!89+ !)$%*-/13321/,Z *3*)-/0/+&$$! 6A:0,8B=1+)/68.%/(,9=2% ")$"%)-02331/31)/().241+%##! *79/)/:<651/33)2<8.6=9. !$%,56643/75,'&).340+&#!$$%#! .5.)/46682%#$$-973:=<7[ !$'+4:964063+( ,33/+(&'),*)'# "%%.2379:1&"%(&.36@?@D5 !$%')/8:86>=2)&!!-231 34772+* &46339C@4+,3/)/:<D/8J=' "%'))+336@3(/)%#%,34569<=?CE5,)! #'21\ .7@C>9;99<9@CAE05J?,%$(.33/+,/26/)(,& #,0258<?ADGE2 "'(# "%),,/6983$ &4<9+4DD>?J>/*-6;<6,,/25.))3,' ",.0369;=AGE. !%%(,.040' 2A?EA4*+/683*.493/($!/-, 0246689:AC7% $%##(.23& :96,#"%)*(%(364,%"!!"560&)/<9;989;>3$ "03., PQ UUUUUU wwwwww iiiimm wwwwww UUUUUU DDDDDD """""" wwwwww UUUUUU DDDDDD """""" ~ffff ffffff ffff33 ff33ff ff3333 33ffff 33ff33 333333 Cancel You did not enter any find criteria; all records will be displayed.C) Cancel No records match this request.E) )=400